Magnum One

home *** CD-ROM | disk | FTP | other *** search

/ Magnum One / Magnum One (Mid-American Digital) (Disc Manufacturing).iso / d13 / pcmpr88.arc / PCMPR88.DOC < prev

Wrap

Text File | 1989-02-26 | 92KB | 1,306 lines

PC MAGAZINE Productivity Columns Index For Vol 7, 1-22 (Jan-Dec 1988) ------------------------------------------------------------------------------- Subject Title Num Page Description ------------------------------------------------------------------------------- 123 Relative Cells In 1P357 String formulas to allow relative Macros cell references in macros Zero Suppression Bug 1P358 Problems when zero suppression is on Point Mode Revisited 2P327 Use Edit key instead of the Up or Down keys Managing Files 2P327 Formulas to convert dates into serial format if importing disk directories Converting Date Labels 2P328 Formulas to convert dates into serial format if importing database files Parsing Filenames 4P375 Use @TRIM function to strip leading and trailing spaces from filename /File Extract Mystery 5P306 Inconsistencies in locating informat- ion extracted with File Extract @AVG Trap 6P303 @AVG wrong if labels also in range Ranking Without Sorting 7P343 Use Boolean logic instead to rank values in a column Errors 17P308 7P343 Ranking Without Sorting Ranking Formulas 17P306 Better standard ranking techninque then method described in 7P343 Canceling {ONERROR} 8P279 How to cancel and create conditional error trapping 123 Returning From DOS 8P280 Batch file to remind user to return after shelling out to DOS Search And Return Again 9P354 GoTo key lets you browse worksheet and easily return to starting point Underlining Labels, 9P354 Formulas for underlining centered, Part 2 left, and right aligned labels Calculating A Single 9P354 Use F2 and then Enter Cell Creating A Date Format 9P356 Formula to convert all-numeric date to full form (ie January 1, 1988) A 1-2-3 Mystery 9P356 Inconsistancy in @IF recalulation of labels as opposed to values Copying Tricks 10P341 Leave blank rows or columns between multiple copies of a cell or range Exact Matching Lookups 10P341 An exact matching @VLOOKUP function for numeric values Finding The Term Of A 10P345 Formula to calculate the number of Loan payments required to pay off a loan Canadian Conversion 11P351 Formula to calculate mortgage payments for Canadian banks 123 The Problem Of 1900 12P315 Formula to compute day of week before Feb 29, 1900 Phantom Recalculations 12P315 Recalculation will occur before printing if the /Print command follows a {FOR} loop even if manual recalculation is set More On The F3 Key 12P316 Comment on using F3 and GoTo keys to display, copy, move, erase named ranges Interpolating With 12P316 How to interpolate values so @VLOOKUP @VLOOKUP returns more precise results Query Find Trick 13P414 Instantly edit cells /Data Query Find locates Calculating Grand 13P416 Formula to calculate grand total of Totals multiple section worksheet Aligning String 14P424 Formulas to center & right align the Formulas results of string formulas Extra Page Feeds With 15P345 How to avoid Hidden Columns Pause With {GET} 15P345 How to create in macro Display Full Screen 16P320 Use GoTo (F5), Name (F3), Name (F3), List Of Range Names and select range name with cursor 123 {FOR} In 123 & Quattro 17P305 Differences for negative step value File Formats For 123, 17P306 Book published by Addison Wesley Symphony & Jazz Upper ASCII Box 18P411 How to obtain for Rel 2.01 Characters /Data Query Find Bug 20P375 If using @D function and automatic recalcuation in Rel 2.01 Upper ASCII Characters 20P376 Use Compose key, @CHAR, or Alt and 3 digit ASCII code on numeric keypad Plot More Than 6 Data 20P376 How to plot on a single XY graph Ranges Strip Leading Zero's 21P363 Formulas to convert 0.123 to .123, -0.123 to -.123, etc Return From DOS After 21P364 Simple batch file 123.BAT Using /System Expanding Range 21P364 Does not change reference, not a bug Find Misspaced Labels 21P366 Use /Range Labels Right command 123 Forgotten Password 21P366 Use Password by Vericomp Publishing to find in encrypted worksheet Using File I/O For 22P271 Using ANSI.SYS, modifying character Screen Display translation tables in 123.SET ------------------------------------------------------------------------------- 123 MACRO More On Inverting 2P327 Macro to invert columns of data Columns Using The {?} Command 2P329 Pause a macro without danger of the macro stopping if Enter isn't pressed Informational Menus 3P355 Macro to present information prompts to user Date Values Into Labels 4P375 Macro to convert serial date values into labels Trailing + And - Signs 4P376 Take trailing - signs and put them before the number More Data With Trail- 20P381 Conversion formula ing Polarity Sign Learn Mode For 1-2-3 5P305 Keystroke macro to implement a learn mode Pausing Macros 5P306 Macro to duplicate SuperCalc4's {suspend} command Widening 1-2-3 Columns 6P303 Macro to size column for longest label Error 17P308 Widening 1-2-3 Columns, 6P303 Stopping Autoexec 6P304 Macro to give you several seconds to Macros prevent execution 123 MACRO An Editing Macro 6P305 Macro to add block delete Saving A Cell Location 7P344 Macro to store location of a cell and return to it later Structuring Your Macros 8P283 Protect macros from the effects of inserting and deleting columns Restoring Range Names 9P353 Macro to restore range names using info in /Range Name Table command Modifying Protected 10P342 Macros to allow users to change label Cells or value entries in protected cells Trapping Ctrl-Break 11P349 Macros to give user options for canceling a macro Calculating Letter 11P350 Macro the converts numeric test Grades scores into letter grades A Date Series Macro 13P413 Macro to enter a series of month spaced dates in a column Saving A Cell Location 13P413 Macro uses a subroutine call to return saved addresses of cells Save & Return - Again 14P423 Macros to return to a cell and display the same cell as before 123 MACRO The {IFKEY} Command 14P427 Undocumented command in 123 V2.01 Six Digit Labels To 15P346 Macro converts date labels into Serial Dates serial date values Period Key Changes 15P346 Macro determines the addresses of Cell Coordinates cells at the corners of range Long Recalc Finished 16P317 Macro recalculates worksheet and Alarm sounds alarm when finished Using {WindowsOff} & 16P317 Prevent users from rebooting when {PanelOff} used in macro Return To Start Place 16P318 Use range names or {LET} or {ONERROR} Macros to return to start location Flashing Display 18P411 Macro to present flashing message to Messages user Annual Interest Rate 19P357 Several macros to calculate loan For A Loan interest rates Date In DDMMYY Format 21P363 Macro to enter in current cell 123 MACRO Start Macro In 21P364 {DISPATCH @CELLPOINTER("ADDRESS")} Current Cell ------------------------------------------------------------------------------- 123 PRINT Shades Of Meaning 1P357 Printing spreadsheets in different patterns on an HP LaserJet Plus Hiding Rows 3P355 Use vertical bar in first column of print range Measuring A Range, 8P280 Measure print range width using Revisited easily created ruler or a macro LaserJet Setup Macros 16P320 Macros to automate print configuration setup ------------------------------------------------------------------------------- ASSEMBLER Examining The MS DOS 1P349 Get the address and length of the Environment variable portion of the environment string with GETENV.ASM Thank You, IBM 1P366 Patch DOS 3.2 EXE2BIN.EXE to work with DOS 3.3 Vanishing Programs 1P391 Use EXE2BIN from DOS 2.1 with DOS 3.3 Jumping To Conclusions 1P385 How location counter and pre-fetch queue work; demo of pre-fetch queue in operation Changing The MS DOS 2P321 Change environment variables with Environment PUTENV.ASM Macros In Assembler 2P353 Pros and cons of using macros From ASCII Strings To 3P347 ASCII string to 16 and 32 bit con- Binary Bits version routines ATOI.ASM & ATOL.ASM Turning Binary Values 4P369 Convert integers and longintegers to Into ASCII null terminated strings with ITOA.ASM and LTOA.ASM Demystifying The 6P297 How to access C's printf in assembler Printf Function OS/2 Programming On A 7P325 Write assembler with MASM 5.0 and Budget OS/2 Ver 1.0 ASSEMBLER Improving Output 7P329 Routines LCVT.ASM to convert 32 bit Formatting In MASM integers to strings and HTOL.ASM to convert hexdecimal strings to 32 bit integers Power Programing 8P269 How to build library PP.LIB. Correct- Library ions to SHOWENV.ASM, ITOA.ASM, LTOA.ASM, GETENV.ASM, PUTENV.ASM. Writing TSR's. Comments on segment assignment, DGROUP, Combine Type, ASSUME, EXEC parent/child MASM Time And Date 10P325 Convert binary to ASCII with TD.ASM Formatting Routines Converting ASCII Time 11P335 Convert ASCII to DOS binary format And Date Strings with SCANTD.ASM Moving Bar Menus 12P345 Two assembler programs SLASHBAR and MAKEBAR were presented 5/26/87 (10P313, 10P339) Keeping FileNames 13P397 Store incomplete file names in drive, Fully Qualified path form with QFN.ASM "Smart" Batch Files 13P420 Batch files that help manage MASM compile/link operations Moving File Pointers 14P458 Progamming LSEEK function 42H RET Instruction 15P377 Differences between four forms ASSEMBLER MASM Programming For 16P307 Quicksort algorithm for integers Quicksort with QSORT1.ASM Recommended Book 16P345 Assembly Language Primer For IBM PC & XT, Lafore, Plume/Waite Keeping In Touch With 17P297 More on QFN (7/88); improved versions Readers of ARGV.ASM & ARGC.ASM (12/22/87); alternate macro assemblers; sources for floating point conversion routines; DOS error handling routines String Handling 18P403 Most useful routines Routines In C & MASM Assembly Language 19P345 Routines to compare, search, validate String Routines and find one character in a set Manipulating Strings 20P363 Routines for concatenation, duplicat- In MASM ion, extraction, translation, all lowercase, all uppercase MASM String & Sorting 21P349 Routines for case insensitive string Routines search/compare and Quicksort ASSEMBLER Parsing Command Lines 22P261 OS/2 versions of ARGC.ASM (number of In OS/2 command line arguments) & ARGV.ASM (address and length of command line argument) ------------------------------------------------------------------------------- BASIC Nonexistent Numbers 1P375 Many fractional numbers can't be displayed by BASICA interpreter A Nonexistent Numbers 11P367 Use double-precision math or long Fix integers to lessen cumulative errors Comprehensive Dating 2P345 Date manipulation functions that do many calculations Free Calculator 3P365 Access math functions on command line with CALC.BAT A Better Pause 3P373 QB routine to create a pause for a specified number of seconds even if midnight passes during the pause Leaving BASIC 3P379 How to return to DOS when program ends Rebooting With BASIC 3P381 Warm and cold boots from within BASIC EGA Screen Printing 4P391 Subprogram to print EGA graphics on HP LaserJet BASIC Numerical Formats 4P398 Symbols (!,#) after number indicates format Mimicking DOS's EXIST 5P329 See if file exists, finds hidden and In BASIC system files with FILEXIST.BAS BASIC Scrolling Messages 6P315 Subroutines to create a rotating prompt message Avoiding Printer Errors 7P357 Subroutine checks printer ready using BIOS service 17h Warm Booting From BASIC 8P301 Subroutine to warm or cold boot using BASICA, QBASIC, or TBASIC Using A Mouse In BASIC 9P373 Routines to allow TBASIC to access MS Mouse object library MOUSE.LIB Advanced Graphics In 11P279 Create graphics-like animation and BASIC tiling in TBASIC and QBASIC A Nonexistant Numbers 11P367 Use double precision math or long Fix integers to lesson cumulative errors Include File Curiosity 12P337 Length of QBASIC.EXE file depends partly on order of subprograms Using APPEND With 13P419 Danger of overwriting files when BASICA using DOS 3.3 APPEND Creating Custom Fonts 13P435 Create & download custom fonts to Epson or IBM graphics printer Bouncing Ball Menus 14P448 For use with games & children BASIC Passing Arguments 14P457 How to pass arguments from batch Using DOS files to interpreted BASIC 3.0 Error Checking File 15P367 Check non critical errors with Copy FILECOPY.ASM for QBasic Turning .COM Files 16P263 Convert binary files into BASIC ASCII Into BASIC with MAKEBAS.COM Number/Variable 16P339 Explanation of methods Storage Formats Smart Linking 16P341 With QB 4.0, compile & link manually from DOS if using custom library Run Programs Faster 16P342 Use DEFINT A-Z at start of program More Resolution Than 17P334 Use ON PLAY command instead ON TIMER Rounding Floating 18P435 Functions to round value to specified Point Numbers number or decimal places or to specified nearest fraction Hide Copyright Notices 18P437 Use DATA statements QuickBASIC 3/4 Object 18P437 Comments, cautions, limitations File Formats BASIC REDIM & DIM 19P390 Using REDIM in QuickBASIC Unprotect Files Saved 20P389 BLOAD file UNPROBAS With P Option QB 3.0 Bug 20P407 Assembler routines compiled within editor generate faulty .OBJ module Cracking The Lotus 21P297 Manipulate date in 1-2-3 worksheets Spreadsheet Code with QB 4.0 Multiple Keystrokes 21P389 Function to recognize combined keys (Ctrl-PgDn, Alt-Home, etc) Write Screen SideWays 22P296 Print sideways in graphics mode with SIDEWRIT.BAS Lost Files 22P300 Periodically close files to prevent loss if PC hangup or power failure Sorting Huge Files 22P300 Sort files to large to load into memory with QSORTFL.BAS Endless Loop Hangup 22P300 Recognize Ctrl-Break with TBasic BREAK.INC BASIC Find Monitor Type 22P304 Examine memory location 463 hex ------------------------------------------------------------------------------- BATCH Batch Magic 1P363 Batch files that read variables from the environment for month, date, weekday, cpu type, and video mode Faster ERRORLEVEL 2P334 How to simplify IF statements in Tests ERRORLEVEL tests Environment Strings 2P353 Use environment variables to control flow in a DOS batch file Batch File Starters 2P359 MS-DOS Handbook and BOSTON.DOC teach how to to write batch files ERRORLEVEL Made Easy 3P359 Set ERRORLEVEL choices and results on command line with OPTION.COM Path Magic 4P380 Batch files to add or remove sub- directories from the path temporarily Batch Branching 6P308 Batch files that eliminate GOTOs Shortcuts when branching in other batch files Heading Home 6P309 Return to a preset directory or new one with HOME.BAT Find It With Xref 6P312 Search for one word strings in DBASE and ASCII files with XREF.BAT Checking Disk Status 6P322 Batch files can use DSKREADY.COM to verify if drive is ready BATCH Real Time Batch File 7P350 Send a command to a batch file when Entries it executes with SAMPLE.BAT Pause Without PAUSE 10P348 Create a flashy rotating prompt and pause for batch files with INFO.COM Show Me The Way To Go 14P431 Change drive & directories & return Home later with RETRNDEM.BAT Using ERRORLEVEL 14P461 How to use with test disk ready batch file Using DOS Environment 15P353 How to use environment variables for subroutine calling in batch files Batch File Labels 15P354 Use colon in front of comment line Change Directories 15P354 Change directories without the backslash key with TO.BAT Missing Replaceable 15P380 Add extra character to each side of Parameters equality test String Searches 16P328 Find a string in multiple sets of files with FND.BAT Copy Multiple Sets Of 17P313 Copy using SHIFT in MCOPY.BAT Files BATCH Add New Text To File 17P314 Append AUTOEXEC.BAT with INSTALL.BAT Combine Multiple Batch 17P314 Example DO.BAT to combine into single Files file Advanced Techniques 18P353 Replaceable parameters, environment variables, SHIFT, IF, FOR Conditional Branching 18P417 Use state of Shift, Ctrl, & Alt keys with SHFTPICK.COM & ERRORLEVEL Simulated CASE State- 20P383 Replace IF ERRORLEVEL with GETKEY.COM ment in faster menu selector BAT_CASE.BAT Get Date In 20P389 Make today's date available to all Environment batch files with TODAY.BAT and CURRENT.BAT Print Blank Line For 22P283 Use DO_CRLF.COM BATCH All DOS Versions ------------------------------------------------------------------------------- C Examining The MS DOS 1P349 Demos of the envp and getenv routines Environment Redirect The Printer 1P375 Capture (redirect) printer output in a disk file with REDIR.C Changing The MS DOS 2P321 Change environment variables using Environment the putenv function From ASCII Strings To 3P347 ASCII string to 16 and 32 bit con- Binary Bits version routines ATOI.ASM & ATOL.ASM as C library functions, comment on QuickC and TurboC Stamping 3P373 Date stamp last directory backup with Subdirectories LAST.C Screen Dumps In C 3P379 How to generate a Print Screen interrupt Dialing Phones With C 3P380 Send dial commands to a modem Turning Binary Values 4P369 C library functions itoa, ltoa, Into ASCII ecvt, fcvt, gvct for binary to ASCII conversion Understanding C 5P299 How to use the function scanf Functions: Scanf Centering Text Output 5P330 Center screen text with STR_CENTER() macro and center() function C Demystifying The 6P297 How to use printf Printf Function Counting Bytes With 6P316 Pipe DIR listings to get total size Pipes+ of all files in directory with BYTES.C C Comments 8P269 B-Trees and Quick C versus Turbo C Compressing With Bit 8P301 Reduce memory overhead with bitmaps Maps and bit manipulation using BITEST.C Formatting Date and 9P343 Routines tcvt, dirtcvt, systcvt, Time in C dcvt, dirdcvt, and sysdcvt to format date and time better than C library routines 1-2-3 Like Menus In C 10P359 Add a 1-2-3 style menu interface to other applications with MENU.C Handling Date And Time 12P309 Convert ASCII time and date strings Strings In C to binary with SCANTD.C Merging C & ASM 13P436 Merge C source code with Turbo C Listings assembler output with MERGE.C Writing Optimal C: 14P345 Optimizing size, estimating space, Part 1 models & overlays, shrinking data size, reducing code size Writing Optimal C: 15P285 Measuring execution time, control Part 2 structures, register variables, arrays or pointers, intinsics vs functions, alias checking, using look-up tables, counting down, near & far routines C Fully Qualified File 14P411 Qualify partial filenames with QFN.C Names In C Master Environment 14P445 Make substitutions to Master Environ- Changes ment block variable with PATHSUB.C The Quicksort 15P341 Quicksort algorithm with QWIKSORT.C Explained MS WORD Keywords 16P340 Find single word or string with SFIND.C Keeping In Touch With 17P297 Using TD.C (5/17/88) with Turbo C; Readers Turbo C stack size; more on using printf (3/29/88) String Handling 18P403 Most useful routines Routines In C & MASM Numbered Listing 19P390 Generate a source listing containing line numbers with NUMLIST.C Wordstar 4.0 Extended 21P390 Force use as extended characters with Character Support WS4XLATE.C filter. C Write Direct To Video 22P295 Access video RAM with QWRITE.C Buffer ------------------------------------------------------------------------------- COBOL COBOL On PC 20P411 Advantages of using PC for program development ------------------------------------------------------------------------------- COMMUN- FCC $5 Docket Revisited 4P401 Congressional interest in FCC's ICATIONS proposed rate hike for data calls Archiving MCI Mail 12P332 How to archive and access using Messages Lotus Express Communications & Video 13P351 Set communication parameters and Setup With SetMode video mode with SETMODE.COM RS232 DCE & DTE 17P350 Null modem connections Asynchronous And 19P409 Definition and description Synchronous PC User's Guide To 20P311 Phone system constrants, data xfer Modems overview, low-medium-high speed modems, modem features, error corr- ection, internal vs external Which COM Ports 21P408 How to determine using DEBUG Installed ------------------------------------------------------------------------------- DATABASE Prosise On Prosise 5P309 Print CARDFILE (10/13/87, 17P401) data with CFPRINT.COM Productivity Columns 21P404 Located in Editorial Product Index Summary in back of magazine ------------------------------------------------------------------------------- DBASE Beyond Len(254) 1P371 Get logical expressions to work when they exceed dBASE's maximum SECS() Appeal 2P341 FoxBASE user defined functions that track elapsed time between events DBase III Plus Menu 3P369 Moving litebar menu with LITEBAR.PRG CHR() SET:dBASE 4P385 Show full IBM character set within dBASE with SHOWCHR.PRG dBASE To WordPerfect 4P387 Translate dB III data in a format for WordPerfect mail merges Hiding The DBASE Cursor 5P321 Turn the cursor on and off with CURSHIDE.BIN No_Cursor Clipper 5P323 Undocumented feature turns cursor on and off Handling Leading Zeros 6P311 Pad numbers with leading zeros Find It With Xref 6P312 Search for one word strings in DBASE and ASCII files with XREF.BAT Canadian Postal Codes 7P353 Format a dBASE field to accept postal codes of different countries DBASE Round() Function, 8P295 Handling of ROUND() function by Square Hole Clipper, dBase III, and FoxBase Color Printing From 8P295 Send color printing instructions dBase using Escape sequences USEing Blank Filenames 9P365 Put CHR(255) blanks in filenames to make them hard to access Faster Than APPEND 9P368 Use COPY with WHILE instead of APPEND with FOR Form Feeds Revisited 9P383 How to determine use of network resources from dBASE and Clipper dBase Multiple File 10P356 Predict how many disks are needed to Sizer backup a group of dBase files with FSIZE.PRG More dBASE III PgDn 11P361 Access specific fields in a group of Ideas records more easily INKEY() Values Chart 12P331 List of returned INKEY() values to build menus dBASE Call Home 13P428 Find current drive and directory in dBASE, DBXL, Quicksilver, FoxBase Current Drive/Sub- 13P431 Determine current drive and directory directory in Clipper DBASE Single Key Find 14P437 Patch to access DB3+ FIND Shortening Link Times 14P440 Timing using PLINK86, MS link, Tlink SUM & COUNT Together 15P359 How to perform in one pass Auto Print Screen 15P359 Use PRINTSCR.BIN inside DB3+ 10 Character Variables 15P360 How to initialize Long Expressions 15P362 Define memory variable, S, as one space Underlined Reports 16P333 Use DB3 Report Form generator or DB3+ IIF(RECN()) Label Printing 16P336 Pad columns with a space Appending Records 17P325 Universal method for standard memvar initialization Print Labels On HP 18P430 DB3 .LBL program LaserJet DBASE Clipper Memory 18P433 How to reduce memory requirements for Reduction Summer '87 release Diskette Backup 19P381 Backup DB3+ files for floppy disk with HD2FLOPY.PRG Speed Up Execution 20P397 Temporarily turn off indexing Force Blank Lines 20P399 Use CHR(13) in .LBL outputs Speed Up Execution 20P400 Use ?STR(RECN()) instead of RECN() DB3 Database Linking 21P381 Deleted records not ignored in Bug secondary database Center Text 21P382 Procedure for centering messages or text headings Monitor Progress 21P382 Use Clipper function Rec_Sho ASCII 255 In FileName 22P289 This file security method creates problems with PC Tools, XTree, dBXL Indexing On Floppy 22P294 Faster to Index to hard disk then copy to floppy with DOS ------------------------------------------------------------------------------- DISPLAYS Custom Design Your Own 1P311 Build and access files of custom Help Screens pop up help screens with HELP.COM Capture Your Own Help 1P325 Create files of screen images for Screens HELP.COM utility with CAPTURE.COM Snipper Snafu 1P332 Bug fix for SNIPPER (10/27/87 18P359) Dress Up Your Help 2P291 Add colors, patterns, lines to help Screens screens and pop ups with PAINT.COM Off Color Monitors 2P354 Mono monitors designed to work with CGA's often produce blurry text EGA Doldrums 2P354 EGA cards can slow down the performance of a system depending on on the EGA BIOS is written EGA Aware MORE 5P311 Patch DOS MORE command so it will work with a 43 line display EGA 43 Line Mode 5P313 Clear EGA screen to blue text on 43 line white background with CLSEGA.COM Longer EDLIN Displays 5P313 Patch to make P command work on 43 line display Multiple Monitors 6P321 Combinations of multiple monitors and boards that will and will not work DISPLAYS Partial Print Screens 11P353 Take over Ctrl-PrtSc and print a portion of screen with PRNBYLIN.COM Snow Removal 11P379 How to prevent snow on a CGA when program writes directly to video memory BLANKINS.COM 12P321 Blank screen temporarily by turning the colors to black on black BORDER.COM 12P321 Set border color from command line on CGA COLOR.COM 12P323 Set foreground and background colors from command line and clear screen to those colors COLOR2.COM 12P323 Set foreground and background colors from command line but leave the contents of screen intact COLORPIK.COM 12P325 Change screen colors by pressing arrow keys COLORSHOW.COM 12P325 Show all possible foreground/back- ground color combinations CURSOR.COM 12P326 Set cursor shape CURSOR2.COM 12P326 Set cursor shape interactively by pressing the arrow keys DISPLAYS PAGE.COM 12P326 Switch among text pages 0 to 3 on a color system and identify the current video page PAGECLS.COM 12P326 Clear any 80 by 25 screen to the existing screen colors and on the current video page A 132 Column EGA 12P346 How to find an EGA board that will display 132 columns The EGA Border 12P347 See 2 part series Aug 86 (14P367) and 9/16/86 (12P311) Adding Color To The 12P347 See SPECTRUM.COM 6/23/87 (12P311) EGA Communications & Video 13P351 Set communication parameters and Setup With SetMode video mode with SETMODE.COM Brightening Up 13P419 Force CGA to use its brighter color Graphics palette with INTENSE.COM Simultaneous Displays 13P448 Not possible without writing separ- ately to each display Making Your Own 15P305 Modify, create, & load screen fonts Screen Fonts on EGA or VGA with FONTEDIT.COM DISPLAYS Enhance Batch Files 21P371 Replace Esc with ~ using ANSI.COM to With ANSI.SYS simplify communication with ANSI.SYS ------------------------------------------------------------------------------- DOS Thank You, IBM 1P366 Patch DOS 3.2 EXE2BIN.EXE to work with DOS 3.3 Version Madness 9P362 Another way to patch DOS 3.2 EXEBIN to work with DOS 3.3 Vanishing Programs 1P391 Use EXE2BIN from DOS 2.1 with DOS 3.3 Running Programs 3P321 Run program in any directory, whet- Painlessly her or not you have PATHed to them with RUN.COM Disappearing Act 8P288 Methods to hide AUTOEXEC.BAT and CONFIG.SYS from software installation programs Another Approach 8P293 How to restore AUTOEXEC.BAT, PATH, and TSR's loaded after bootup The SHELL Statement 8P309 How DOS SHELL affects the environment and user interface Fooling COMMAND.COM 9P360 Run batch files and programs with names identical to internal DOS commands by prefixing with drive letters Bootable Software 9P377 DOS can't boot up some game softeare because software doesn't use DOS Exploring File 10P367 How DOS tries different filename Extensions extensions to process your commands DOS A Hostile Environment 10P368 Extra spaces in the SET COMSPEC= statement can create problems Error 18P443 Hostile Environment, 10P368; should be SET COMSPEC=C:\COMMAND.COM REBOOT.COM 12P326 Perform a warm/cold boot or abort the rebooting process Patching REMOVE.COM 13P450 Patch utility (8/87) to eliminate Press ENTER prompt Using The COMSPEC 14P457 Purpose of the COMSPEC variable Variable DOS Redirection 15P353 How to speed up repetitive tasks by redirecting a file to COMMAND.COM Add Subdirectories To 16P328 Automate process with ADDPATH.BAT PATH Drive/Directory In 16P331 Use PROMPT $P in AUTOEXEC.BAT Prompt DOS 3.3 FASTOPEN 17P322 Caution when subdirectories are Anomally renamed CLS Command 17P341 Detail description of how it works using disassembled code from COMMAND.COM DOS Modify PATH With 20P384 Save current PATH in environment, File make new PATH and restore original PATH with SAVEPATH.BAT PROMPT Reminder 20P393 Use SET and SETPROMP.BAT to remind you that you are in DOS shell (sec- ondary copy of COMMAND.COM) TYPE With Pause 20P411 Use MORE < filename Environment Variables 20P423 How to safely manipulate In DOS 3.3 MicroSoft Tech Support 21P395 (206) 882-8089 Conceal COMMAND.COM 22P284 Use SHELL, COMSPEC, and environment DOS Uninstalling Device 22P308 Why you must reboot Drivers ------------------------------------------------------------------------------- FILES Moving Example 2P331 Move a file between directories without losing it using MOVEIT.BAT DOS Redirection 3P380 Temporary files made by DOS redirect- ion and where the names come from Checking Up On Verify 4P397 Operation of DOS VERIFY, why its slow and unreliable Read Out And Touch 7P309 Alter file time and date stamps with Your Files TOUCH.COM Recovering From Recover 9P360 DOS RECOVER can easily wipe out disk structure and all file names Verifying With COPY 10P371 The /V parameter has the same effect as turning VERIFY ON Compare Simplifies 11P297 Find differences between two versions File Matchups of text/binary files with COMPARE.COM DOS 3.1 BACKUP Bug 18P417 Will not copy large read-only files Multi Copy DISKCOPY 18P418 Patch PC DOS 3.3 DISKCOPY to make multiple copies withot renaming the original Using DEBUG On Files 19P369 Load, alter, & display nontext files FILES Foil Unerasing 19P374 Prevent unerasing of file with Utilities WIPE.BAT *.* Alternative 20P394 Use period (.) instead. Conceal Programs And 20P412 Use PC Magazine's ATTR.COM (6/10/86) Directories Update File To 21P379 Use COPY/B filename+,, Current Time & Date Archive Bit 21P401 Comprehensive explanation Secret Files And 22P286 Use ASCII character 255 Directories FILES Undocumented DOS 3.3 22P286 /H skips message "Insert disk and FORMAT Switch press any key" ------------------------------------------------------------------------------- FORTRAN FORTRAN Pitfall 17P333 Passing constants to a function Comma Delimited 18P436 Function to write real number with Numbers comma delimiters Embed Printer Control 19P394 How to use ASCII control characters Codes in FORMAT statements for writing to sequential files Assembler Routines 21P398 Registers that should be saved ------------------------------------------------------------------------------- FRAMEWORK Date In DDMMYY Format 21P363 Macro to enter in current cell ------------------------------------------------------------------------------- KEYBOARDS Keyclick Toggler 4P379 Toggle keyboard click sound on and off with CLICKER.COM One-Key Scroll Lock 7P347 Start or stop scrolling when Scroll Lock is pressed with NOSCROLL.COM Splitting Up The 8P233 Turn keyboard combinations into key- Keyboard Combos stroke sequences with STAYDOWN.COM Staying In Sync With 10P299 Report/fix the state of the toggle Your Keyboard keys and synchronize the LED's with TOGGLE.COM Right Hand Control 10P347 Create a right hand Ctrl key for old AT keyboards with RHCTRL.COM Unlocking NumLock 11P378 Turn off NumLock at bootup with NUMLKOFF.COM in AUTOEXEC.BAT Putting An End To 12P277 Disable hotkeys from TSRs and macros Hotkey Hassles to prevent conflicts with ALLKEYS.COM Swap Capslock & Ctrl 18P441 Reassign AT Enhanced keyboard keys Keys with memory resident CTRLCAP.ASM PC-XT & 101 Key 19P404 BIOS must know whether 84 key or 101 Keyboards key keyboard is being used KEYBOARDS Switch Between Keypad 21P372 Use Shift key Numbers & Cursor Keys Repetitive Operations 21P372 Assign text strings to keys with ANSIKEY.BAT ------------------------------------------------------------------------------- NETWORKS Unwanted Form Feeds 1P393 Use Applied Technology's Systemizer PC LAN to strip out PC LAN's extra form feeds Headed For The Promised 1P394 Centram's Tops is ideal for single LAN AT and PC sharing data and printers PC To HP Connections 1P394 Ungerman Bass interface unit with Reflection HP connects PCs to HP3000 Garbles And Overuns 2P359 Getting garbled data and receiver overuns when running a VAX EDT editor Host Initiated File 2P359 PCTerm, SmarTerm, and Crosstalk let Transfer DEC VAX download unattended Software LAN Analysis 2P360 Cables from Codenoll, PureData, and Tools Proteon work in noisy factory A No-No On Shielded 3P383 Connect StarLAN with fiber optics, Wire and Pure Data or Codenoll fiber cards Finding The First 3P383 Make Novell log ons independent of Drive the LASTDRIVE parameter with LASTDRIV.COM More Storage Under 3P383 More storage under NetWare for hard Netware disks like Priam's with Phoenix BIOS LAN Printing Tip 4P401 Print with 3Com's 3+Share to network printer without intervention NETWORKS LAN For All Seasons 4P401 Use EtherLink under VINES, NetWare, and 3+Share for software development LAN Courses 4P401 Novell, 3Com, and Architecture Tech- nology off good LAN courses WAN Of LANs 4P402 Banyan's VINES with Telebit's Trail- blazer modem to link LANs to a WAN Using Single User 5P343 Limit the number of active copies of Programs a program with N_COPIES.BAT Sharing A Single 5P344 Method to share by all stations AUTOEXEC.BAT System/36 File Transfer 6P325 Transfer packed EBCDIC data from System/36 to PC Economical IBM 6P325 IBM Network Baseband Adapter has Compatibility almost the same performance as Token Ring DOS Inconsistencies 6P326 Problems with booting Novell file servers with DOS 3.2 and 3.3 PC LAN Form Feed 6P327 New update prevents unnecessary form Corrected feeds ARCnet Limitations 7P365 Station-to-station setup of Standard Microsystems ARCnet cards NETWORKS Application 7P365 Novell and 3Com have directories of Recommendations LAN software for specific markets NetWare Token-Ring 7P365 DOS 3.3 "out-of-environment" errors Problem on Novell's Advanced NetWare 2.0 LAN Tuning Tips 7P366 Use RAMdisks to increase network performance and efficiency Codenoll Fiber LAN 8P315 Rate of Codenoll card in Codenet Speed compared with 3Con EtherLink Plus System/36 Data 8P315 Brainwave's OnDemand transfers data from 1-2-3 on PC to IBM System/36 DOS Versions On A LAN 8P315 Versions prior to 3.1 won't run network software such as 3Com's Multiuser Versus LAN 8P316 LAN and clustered CPU system versus Alcatel and Intel multiuser systems Creating A User Log 9P383 DOS batch file to create a system log of Advanced Netware users Error 17P350 Creating User Log, 9P383; up to 7 characters can be passed to DOS 5 Years Ago In PC Mag 9P383 Hayes Smartmodem 1200, Crosstalk, 3Com Ether series, Nestar's Plan 4000 Novell Distant LANs 10P373 Problems booting up a Novell network may be temperature related NETWORKS Stop That Print Screen 10P373 Disable Ctrl-PrtSc on an Orchid network with NOPRTSCR.COM to prevent lock outs. Work Station 10P374 Novell Login script uses station ID Parameters number to determine video card type Network Speed 11P381 Awesome I/O, 10-NET, BatRAM improve peer-to-peer PC LAN on Sytek cards Adding Mass Storage 12P351 Two large disks on a server cut data loads and speed data access Mixing Operating 12P351 Running NetWare, 3+Share, and Systems Tapestry on the same EtherLink cards Wiring Alternatives 12P351 AT&T's Premise Distribution System offers a sensible building wiring plan Do You Need A UPS? 12P352 Novell's SFT NetWare responds to UPS signals and does orderly shutdowns Laptops On LAN 12P353 Connect Computer's Wonunder connects a Toshiba laptop to an Ethernet LAN Stopping Printer 13P453 Stop print spool in 1-2-3 and Word- Spooling Perfect (with 3+Share), & DataFlex Node ID With Ethernet 13P453 Extract network address for 3Comm & C 3C501 EtherLink card with ENADR.C NETWORKS Getting ArcNet's 13P454 Finding a station address on ARCnet Number network running Novell's NetWare NetBIOS Revealed! 14P465 Book Haugdahl's Inside NetBIOS, Architecture Technology Corp NetBIOS Monitor 14P465 Monitor commands sent to NetBIOS services with RNETBIOS.COM Wide Area Links 15P385 For IBM PC LAN links using X.25 Between LAN's network NetBIOS Reporting 15P385 Capture hex return codes sent from Utility NetBIOS programs with NETBIOS.COM Ethernet & IEEE 802.3 15P390 Same except for fifth field Data Frames 10Base5 & 1Base2 15P390 10 megabits/sec coax cable (Ethernet) LAN's 1 megabit/sec twisted pair (StarLAN) NetWare Programming 16P347 Demonstrated with NEWNODE.ASM and Interface NEWNODE.BAT LAN Transmission Speed 16P348 Peer-to-peer networks 90-170 Kbits per sec; Dedicated servers 260-450 Kbits per sec LAN Standards 16P348 IEEE 802.3 for Ethernet & StarLAN; IEEE 802.5 for IBM Token-Ring; IEEE 802.9 for LAN & ISDN integration NETWORKS Slit Capacitors On 17P349 High voltage spark gaps 3Com LAN Cards Favorite Low Cost 17P349 LANtastic (Artisoft) & Simple-Net LAN's (Simple-Net Systems) Select Application 17P349 Use DOS environment variable and Program Drivers batch file IBM PC LAN Startup 18P447 Simplify start-up, connect, and disconnect with PCNET.BAT Two LAN Operating 18P448 Peer-to-peer and dedicated Systems More RAM 18P448 Use LANtastic Operating System (Artisoft) or HIcard (RYBSElectronic) to recover unused address space from 640KB - 1MB area NetWare Activity Log 19P409 Document log-in and log-out activity of each user with USER_LOG.BAT Small Campus LAN 19P409 Hardware & software recommendations Application IBM Cabling Plan 19P411 Definition of cable types 1 to 6 ISO Model Layers 19P411 Definition compared to railroad system NETWORKS Prevent Unwanted 20P419 Use ANSI.SYS to disable Shft-PrtSc, Keystrokes Ctrl-PrtSc, etc PC To Mainframe File 20P419 Simple fix described Transfer Failures Single User Programs 20P420 "Checkout" legal copies with LAN Shell by LAN Systems DOS 3.3 FASTOPEN 20P423 Improves performance on many LAN's PC To Mainframe 21P407 Use API with 3270 terminal emulation Connection software Sharing Printers 21P408 Sources to use with NetWare stations X.25 Services 21P408 Description of the data communication standard Older Etherlink Cards 21P409 How to use with newer 3Com server LU 6.2 And APPC 22P313 Explanation of concepts PC To PS/2 Data Xfer 22P314 Products which use serial and parallel ports NETWORKS CD-ROM On Network 22P316 Problems and solutions ------------------------------------------------------------------------------- OS/2 OS/2's Multiple Video 1P339 How the OS/2 Kernel does graphics and Alternatives the Presentation Manager does text OS/2 Memory Management 2P313 How memory blocks are shared and increased Understanding The OS/2 3P339 Explanation of OS/2 Kernel's keyboard Keyboard functions and piping Keyboard Monitors Under 4P359 Keyboard monitor functions to inter- OS/2 cept I/O Getting The OS/2 5P287 How OS/2 uses threads, screen groups, In Hand and processes for multitasking OS/2 Threads And High 6P283 Problems with using OS/2 threads in Level Languages C programs and C library functions Cleaning Up After IBM 7P299 Organizing OS/2 files on a hard disk Part 1 and making DOS and OS/2 boot disks OS/2 Background 7P361 OS/2 compatibility with DOS software is creation of IBM and Microsoft Cleaning Up After IBM 8P221 Delete unneeded OS/2 files from hard Part 2 disk and how to organize the rest A Budget OS/2 Program- 8P255 OS/2 alarm program WAKEUP requires ing Course only MASM 5.0 and OS/2 1.0 OS/2 Exploring The OS/2 9P329 A look inside the "New Executable" .EXE file file format to see how OS/2 functions using OS/2 hex dump program DUMP Opening A File In OS/2 10P311 How to set the eight parameters that the OS/2 DosOpen function requires IBM's OS/2 Programming 11P321 Faults in IBM version that Microsoft Tools also produces Multiple Threads Make 12P289 Uses OS/2 multitasking to search for Better OS/2 Programs and browse files with FSB.EXE Introducing The OS/2 13P379 Use OS/2 1.1 graphical interface Presentation Mgr to draw nested rectangles in window with BOXES1.C Presentation Manager 14P395 Process key & mouse input with menu Menus in BOXES2.C Presentation Manager 15P327 Using dialog boxes with BOXES3.C Dialog Boxes, Part 1 Multitasking Upgrade 15P378 Hardware and software alternatives Presentation Manager 16P291 Message architecture vs top down Dialog Procedures architecture. BOXES3.C Microsoft's OS/2 17P283 Comparison of IBM OS/2 tools; demo of Programming Tools function calls with PAUSEPOP.ASM OS/2 Dual Mode Programs 18P387 Dual mode .EXE file that runs under Without FAPI DOS & OS/2 eliminating FAPI overhead Teaching The PM To 19P327 How Presentation Manager's standard- Say "Hello" ized overhead provides display flex- ability Getting Started In 20P347 Draw areas of various sizes and fill PM Graphics with different colors using PM The Mouse: Not For 21P339 Role of mouse in multitasking and Wimps graphics based environments OS/2 The Mouse And Its 22P251 How mouse message system works Message ------------------------------------------------------------------------------- PASCAL Encrypting Files 1P376 Encrypt files using a key phrase with CRYPTO.PAS Turbo Pascal 4.0: 2P277 Interrupt procedures, chaining inter- Making The Big Move rupt procedure, direct video I/O, Keypress using inline, overlays, chaining, exit procedures, text file device drivers, fake .OBJ data files Writing On The Side 2P346 Routines to write at an angle for labeling the axes of graphs Filtering Output 2P348 Filter to redirect screen output to a file in addition to screen Binary 3P374 Convert a byte into a binary string with function BINARY Filling A String 3P374 Fill a string with one character for length N with FILLSTRING WalkBack 3P376 User supplied error handler for trac- ing TP3 program flow Adding External 4P392 Save TP3 compiled procedures as Procedures external Cardinal Integers 4P393 Routines to consistently support TP3 unsigned integers Coping With CGA 5P333 Turn CGA video on and off with Vid_On procedure PASCAL Test87 5P333 Check for the presence of a coproces- sor with Has87 function Stuffer Correction 6P317 Error in Stuffer (11/10/87 19P520) Order For Calculations 6P317 Speed up code by changing order of expressions in TP3 For Loop Warning 6P317 Don't force exit from a For loop Bringing ANSI To Turbo 7P357 Technique to use ANSI commands without losing Turbo screen commands Clarifying INLINE 8P304 Method to use named, instead of hex Listings constants in INLINE code Easy Text Entry 9P374 Program to turn a text file into formated Writeln strings Testing For New 9P374 Function to indicate if Enhanced key Keyboards board BIOS is present Structured Function 11P367 Use record type and typecasting to Returns let functions return structured results such as complex product of two complex numbers Fast EGA Output 11P369 Fast plotting of EGA graphs in TP3 with EGA_GRPH PASCAL Seeking Text Files 12P337 TP3 function SeekToText randomly accesses text anywhere in file File Date And Time 12P338 TP3 program to construct strings using date and time of open file Renaming Directories 12P342 Program to rename files or direct- ories even if name contain blanks Real-Time Clock 13P440 Coprocessor clock program creates Display clock display without modifying the clock interrupt Disabling Print Screen 14P450 Disable or enable PrtSc key Setting Color Screens 14P450 Manipulate with TP3 procedure PrtChar Calling Procedures At 15P368 TP3 method to use procedures passed Runtime as parameters Convert Reals From 6 15P371 Program to convert 6 byte to 8 byte To 8 Bytes reals and vice versa Bright Backgrounds On 15P374 Error in program of 12/22/87 p388 CGA Self Modifying 16P341 How to modify TP3 type constants to Programs store configuration information internally PASCAL Using TP4 Exec 16P342 Use $M directive to minimize stack and heap usage Draw Lines On Screen 17P334 Use cursor keys in LINEDRAW.PAS Read Procedure Quirk 18P435 Differences between TP3 and TP4 Flexible Real Number 18P437 TP4 procedure to handle real numbers Entry that begin & end with decimal point Write To Multiple 19P389 Procedures to write and display all Screen Pages CGA video pages DIR File Size Filter 19P394 TP3 program to add file size sum to directory listing TP4 Typecasting 19P397 Typecast variable to match function Virtual Screen 20P401 Program to manage virtual screen larger than actual screen Cursor Shape 20P402 Set cursor shape with CURSOR.PAS Find Video Mode 20P404 Determine video mode with VIDMODE.PAS PASCAL Total Installed RAM 20P404 Procedures to determine installed and available RAM BlockRead, BlockWrite 20P407 Open with block size of 1 to read or Untyped Files write exact number of bytes in file Better Copy & Delete 21P389 Includes built in error checking TP3 Vs TP4 Read 21P395 In TP4 use Readln for string Procedure variables .EXE, .COM Text Filter 21P395 Print ASCII strings if they exceed specified length PASCAL Zero Variables 22P300 Use FillChar procedure ------------------------------------------------------------------------------- PRINTERS Automated Printing 2P331 Run the DOS PRINT command in a batch file without user confirmation Printer Sniffer 2P332 Check which printer port is active with WHICHLPT.COM, Switch between printer ports with PRNSWAP.COM Learning To Live With 3P299 Introduction to LaserJet control Laser Printers, Part 1 sequences (PCL) Learning To Live With 4P347 Create graphic images for the HP Laser Printers, Part 2 LaserJet New Graphics For Old 4P385 Print IBM text graphics chararcters Epsons by downloading fonts in NEWEPSON.DAT to printer Handling Fonts In Your 5P237 How to create and use soft (down LaserJet II load) fonts ASPRN Cures Laser 5P247 Define printer control strings which Printer Headaches are invoked with 2 character macros using memory resident ASPRN.COM Custom Designing Your 6P239 Create and down load soft fonts for Own Fonts HP Laserjet Creating Small Files 6P307 Output numbers from command line for escape sequences with ONCL.COM Printer Port 6P321 How DOS assigns LPTx addresses for Assignments LPT1 to LPT3 PRINTERS Problems With ANSI 6P323 Printers sometimes mistake the $e in ANSI prompts for Escape sequences when Ctrl-PrtSc is used Batch Files For 7P354 Create batch file to send Escape Printers codes with MAKSOURC.BAS Send Hex Codes To Any 16P325 Create .COM files from hex decimal DOS Character Device input using SENDCODE.COM Envelope Printing On 21P223 Procedures using batch file, Display- LaserJet Write 4, Word, Multimate, Word- Perfect, WordStar Professional, XYWrite III+, Keyworks, Metro Envelopes On Lasers 22P233 Memory resident ENVELOPE.COM to Are Easy capture name, address from screen and print them with optional return address on envelope with LaserJet PRINTERS Toggle Ctrl-PrtScr 22P308 Batch file using PC Mag KEY-FAKE On-Off utility (12/24/85) ------------------------------------------------------------------------------- PROGRAM- Programmer's Pop-Up 6P257 Do arithmetic and logical operations MING Calculator in many number bases with CALC.COM ------------------------------------------------------------------------------- QUATTRO Quattro BUG 14P423 Bug in certain @D formulas ------------------------------------------------------------------------------- SECURITY Window Of Opportunity 5P316 A mouse is still active on a DeskPro 286 if the keyboard is locked ------------------------------------------------------------------------------- STORAGE Bouncing Hard Disks 2P354 Effect of printer vibrations Whither Drive B:? 4P398 Dip switch settings affect whether a system recognizes logical drives More On Formating 4P399 Formating 360KB disks as 1.2MB produces many errors Parking A Hard Disk 5P337 Park hard disk heads with PCPARK2.COM Checking Disk Status 6P322 Batch files can use DSKREADY.COM to verify if drive is ready Audible Virtual 7P347 Patch to VDISK.SYS so speaker RAMdisk indicates when RAMdisk is accessed Analyzing Your RAMdisk 9P309 Monitor disk accesses to suggest Needs which files belong on a RAMdisk with RECORDER.COM A Better Drive Sniffer 9P359 Scan the entire alphabet to report all valid drives with DRIVES.COM The Big Chill 9P360 Cool a PC to 40 degrees F to rescue a failed hard disk Upgrade Headaches, 9P378 Upgrading a hard disk from DOS 2.X to Part 2 DOS 3.X complicated by larger cluster size STORAGE Final Format Forum 10P371 FORMAT with the /4 switch formats 360KB disks as 360KB in 1.2MB drives Missing Device Drivers 12P345 Reasons for "Bad or Missing VDISK" error message Bad Sectors On Hard 13P447 How sectors are marked as bad on Disks IBM PS/2 Model 50 hard disks Speed Up Hard Disks 17P255 Cut hard disks reads by up to 50% With DCACHE with memory resident DCACHE.COM Expand Your EMS 18P367 Resize RAM disk without rebooting RAMdisk On Command with XPANDISK.SYS & XPANBOSS.COM RAM Disk For Batch 18P422 Speed access by placing in RAM disk Files & Utilities Missing File Space 18P443 DIR indicates actual bytes used by file; CHKDSK indicates number of clusters used times bytes/cluster Hard Disk Bad Tracks 20P414 Effect on sectors, sides, cylinders, clusters Speed Operation With 21P379 Put COMMAND.COM in RAM disk RAM Disk Gain More Hard Disk 22P283 Optimize cluster usage, merge small Space documents, remove duplicates, reduce cluster size, combine batch files, delete backup files, eliminate sub- directories, use keyboard macros, clean up hidden files, run CHKDSK STORAGE FDISK Rescues Hard 22P286 How to map out bad sectors Disk Head Parking 22P311 Possible conflicts with PROMPT command ------------------------------------------------------------------------------- SUPERCALC Loading SuperCalc4 12P316 Macro to eliminate the need to press a key to complete the program load ERR Bug 15P438 Returns 0 instead of ERR during illegal divsion by 0. Payments & Annuities 18P412 Formulas for various options ------------------------------------------------------------------------------- SUPERKEY Left! Right! 6P311 Use to print right to left for Hebrew Turn It Off 6P312 Redefine keys to turn off features in Wordstar and 1-2-3 More Keys For SuperKey 12P332 Macros to use number, up, down, and arrow keys for DOS macros ------------------------------------------------------------------------------- SYMPHONY Hiding Rows 3P355 Use vertical bar in first column of print range A Trap For Apps 3P356 Macro tests if application is attached before attaching it Running DOS From 4P375 Use DOS.APP and \COMMAND /c in front Symphony of file name, return to Symphony is automatic Erroneous @IRR Results 4P376 Bug returns bad negative values Macro Library Lookups 11P350 Store a lookup table and macro that accesses it in the macro library Query Find Trick 13P414 Macro to cancel {Menu} Query Find and position cell pointer on cell of last record that was highlighted SYNPHONY Duplicate FORM Records 17P305 Macro to make copies of existing records in FORM window ------------------------------------------------------------------------------- SYSTEMS Less Is More 8P287 Run programs that require only 512K RAM by setting RAM known to DOS with MEM512.COM Accelerating Slow Chips 9P377 Why filling in lower 64K of system board memory won't increase speed PC Power Problems 11P377 Comment on amount of time it is safe to leave a PC and its hard disk running unsed Mixing Processors 11P377 An Intel 8087 will also work with a NEC V20 CPU ROMINFO.COM 12P327 Report the date, copyright notice, and ID Byte information embedded in most ROM BIOS chips Instant Speedup For 13P331 Change refresh cycle of DRAM chips Your PC to boost speed with QFRESH The 80XX Parity Flag 13P448 Relation of flag setting to bits in a data operation result RAM Snooping With 14P367 Display ASCII strings and hex seq- RAMVIEW uences in any area of memory with memory resident RAMVIEW.COM IBM Technical Info 15P378 Get Technical Directory by calling (800)IBM-PCTB DEBUG Scripts 16P343 How to use DOS DEBUG SYSTEMS 800 Tech Support 19P386 Call (800) 555-1212 to find out if toll free number available PC Market Confusion 19P401 Multitasking, Extended Edition, Unix, "New" Applications Choose CONFIG.SYS 20P323 Device driver CONFIG.CTL lets you Options At Boot modify CONFIG.SYS while booting up Most Important Program 20P412 File backup program Log Your PC's Activity 21P317 Track dates, times, names or programs with LOG.COM Bug In IBM PC BIOS 21P403 BIOS dated 4/21/81, fix with patch VIDEOFIX.COM, BIOSDATE.COM finds date SYSTEMS Keeping Computer Cool 22P284 Tips to extend life ------------------------------------------------------------------------------- TIME Time For A Change 3P360 Set AT CMOS real time battery clock with GETCLOCK.COM Once-A-Day Batch Files 14P432 Read a program once a day with READDATE, ONCEONLY, & CURRENT ------------------------------------------------------------------------------- WORD(MS) Easier Drop Caps 1P371 Use Windows Write to insert drop caps in text MicroSoft Word As 2P343 Macros to make Word 4.0 act like Wordstar WordStar Word As Wordstar 11P363 Use Prokey to speed up emulation of Wordstar commands Hidden Outlines In 3P371 How to hide outlines used to build Word document in text ASCII To MS Word 5P324 Use WordExchange to clean up ASCII document after its imported to Word Extra Line Feeds In 7P354 How to turn off Tandy DWII printer's Word extra line feeds Multipage Printing 8P298 Print multiple copies using HP With WORD LaserJet Escape sequences Footnotes In MS Word 9P366 How to keep footnote numbers contin- uous in multiple files Delete Word In Word 10P355 Macro to delete word at the cursor or word to right or left Exam Time With Word 11P361 Create multiple versions of exams by using footnote feature WORD(MS) Print Macros In Word 11P365 Macro to print every page in current document MS Word Macros As 12P334 Macros that toggle between turning Toggles feature on or off Single-Word Word 13P428 Using thesaurus as spell checker Updating Word Macros 14P437 Macro to simplify storing Word 4.0 macros Using Commands As Text 14P438 How to recognize key symbols as text Speed Up Glossary 15P359 Use nested macros Entries Macros Using SuperKey 15P362 Superkey macros faster Using With SuperKey 16P336 Pros and cons of using recursive macros Print Subsets Of 17P329 Using hidden text and style sheets Master List Notepad Window 19P383 How to open and save even if filename already exists WORD(MS) Merge Printing 20P398 How to avoid blank lines if fields Addresses are empty. Edit & Update Macros 21P381 Two macros to edit macros in glossary Document Word Count 22P289 Macros to exclude end of document from word count ------------------------------------------------------------------------------- WORD Finding Yourself 2P344 Macros for inserting, saving, and PERFECT finding text markers Numlist 3P369 How to create a list of sequential numbers Printgo 3P369 Macro to print a hand fed multi page document while editing another Default Dilemma 3P370 Alter defaults for entire sessions, not just individual documents What's In A Name 3P371 SAVE files in version 4.1 without changing their name to Y dBASE To WordPerfect 4P387 Translate dB III data in a format for WordPerfect mail merges Under After 4P388 Macro to underline existing text as the cursor advances Control Codes In WP 5P323 Use WP Library Program Editor to search and replace control codes WP Startup 5P323 Load COMMAND.COM to RAMdisk to use WP 4.2 DOS shell on floppy disk system Seeing Footnotes 6P312 Macros to write and edit footnotes WORD More On WP Leaders 7P353 Get right justified text with dot PERFECT leaders XPRINT 7P355 Macro to cancel all active queued print jobs CapStart 8P296 Macro to automatically uppercase the first letter in a sentence Bothdocs 8P296 Macro to edit two documents simultaneously Improved Menu Macro 9P365 4.2 macro to pop up a memo file on the same screen your working on Center Tab 9P368 Macro to tab to center of current margin settings Printer Help 10P355 WP 4.2's undocumented PRHELP.EXE has info about printers Restoring Underline 10P355 Macro to replace underlines removed from transmitted text Surprise 10P358 "Text not modified" message doesn't apply to control codes Proportional WP On HP 11P361 Microspaced proportional fonts on HP LaserJet Series II WORD Fastline 11P363 Macro to quickly draw horizontal PERFECT lines of any length Creating ASCII Files 11P377 Use Ctrl-F5 to create pure ASCII files that DEBUG will accept Forcing Macro Updates 12P331 How to invoke macros modified with WP Library's Macro Editor Speeding Up WP 13P427 Copy WP.EXE to Ram disk Concordance Construct- 13P427 Macros to create a concordance file ion of words and phrases Sorting Fields By Date 14P438 How to sort in chronological order Putting Tabs In WP 14P440 How to use with proportional fonts Headers File Directory As 15P360 Macro to display file directory Initial Screen instead of blank initial screen Speed Up Operation 15P362 Load all programs into RAM using /R on command line Wildcard Searches 15P362 Use Ctrl-X for the character WORD Explicit Printer 16P333 Embed in document so it can be print- PERFECT Defaults ed on any copy of WP with different defaults Changing Soft Return 16P333 Macro to replace hard returns with Codes soft but keep two hard returns between paragraphs Bibliographic 17P325 Macros to build reference list Citations Goto Commands 17P329 Summary of various Goto options Paper Request 18P430 Macro to ask for a new sheet of paper Duplicating Blocks Of 19P386 Macro for copying text block to Text current cursor location Time Log As Doc 2 20P397 Macros to create and store time keeping log DOS Text In Problems 20P400 If upper ASCII characters are displayed, reload file as a true WP formated file Paragraph Fields 21P382 How to assemble using merge feature WORD Eliminate Blank Lines 22P290 In WP 4.2, merge output PERFECT Previous File List 22P290 In WP 5.0, press F5 twice ------------------------------------------------------------------------------- WORD PROC Tiniest Editor You'll 19P281 Full screen text editor, TED.COM, for Ever Need up to 64KB files Display Character 22P307 Read command line and count number of Counts times a given letter appears with FREQ.COM ------------------------------------------------------------------------------- WORDSTAR Enter High ASCII 18P429 Several methods, including macros Characters Second File 18P430 Macro to view second file without closing first Month Names In Spanish 22P290 Patch to 4.0 ------------------------------------------------------------------------------- XYWRITE Count Characters Or 16P334 Implement with COUNT.PGM Strings -------------------------------------------------------------------------------